package cn.invest.merry.module.invest.dal.mysql.zcfzbase;

import java.util.*;

import cn.invest.merry.framework.common.pojo.PageResult;
import cn.invest.merry.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.invest.merry.framework.mybatis.core.mapper.BaseMapperX;
import cn.invest.merry.module.invest.dal.dataobject.zcfzbase.ZcfzBaseDO;
import org.apache.ibatis.annotations.Mapper;
import cn.invest.merry.module.invest.controller.admin.zcfzbase.vo.*;

/**
 * 个股报告期资产负债 Mapper
 *
 * @author 芋道源码
 */
@Mapper
public interface ZcfzBaseMapper extends BaseMapperX<ZcfzBaseDO> {

    default PageResult<ZcfzBaseDO> selectPage(ZcfzBasePageReqVO reqVO) {
        return selectPage(reqVO, new LambdaQueryWrapperX<ZcfzBaseDO>()
                .likeIfPresent(ZcfzBaseDO::getSecname, reqVO.getSecname())
                .eqIfPresent(ZcfzBaseDO::getSeccode, reqVO.getSeccode())
                .likeIfPresent(ZcfzBaseDO::getOrgname, reqVO.getOrgname())
                .betweenIfPresent(ZcfzBaseDO::getDeclaredate, reqVO.getDeclaredate())
                .betweenIfPresent(ZcfzBaseDO::getEnddate, reqVO.getEnddate())
                .eqIfPresent(ZcfzBaseDO::getF001d, reqVO.getF001d())
                .eqIfPresent(ZcfzBaseDO::getF002v, reqVO.getF002v())
                .eqIfPresent(ZcfzBaseDO::getF003v, reqVO.getF003v())
                .eqIfPresent(ZcfzBaseDO::getF004v, reqVO.getF004v())
                .eqIfPresent(ZcfzBaseDO::getF005v, reqVO.getF005v())
                .eqIfPresent(ZcfzBaseDO::getF006n, reqVO.getF006n())
                .eqIfPresent(ZcfzBaseDO::getF077n, reqVO.getF077n())
                .eqIfPresent(ZcfzBaseDO::getF078n, reqVO.getF078n())
                .eqIfPresent(ZcfzBaseDO::getF007n, reqVO.getF007n())
                .eqIfPresent(ZcfzBaseDO::getF080n, reqVO.getF080n())
                .eqIfPresent(ZcfzBaseDO::getF008n, reqVO.getF008n())
                .eqIfPresent(ZcfzBaseDO::getF009n, reqVO.getF009n())
                .eqIfPresent(ZcfzBaseDO::getF010n, reqVO.getF010n())
                .eqIfPresent(ZcfzBaseDO::getF081n, reqVO.getF081n())
                .eqIfPresent(ZcfzBaseDO::getF082n, reqVO.getF082n())
                .eqIfPresent(ZcfzBaseDO::getF083n, reqVO.getF083n())
                .eqIfPresent(ZcfzBaseDO::getF013n, reqVO.getF013n())
                .eqIfPresent(ZcfzBaseDO::getF014n, reqVO.getF014n())
                .eqIfPresent(ZcfzBaseDO::getF011n, reqVO.getF011n())
                .eqIfPresent(ZcfzBaseDO::getF012n, reqVO.getF012n())
                .eqIfPresent(ZcfzBaseDO::getF084n, reqVO.getF084n())
                .eqIfPresent(ZcfzBaseDO::getF015n, reqVO.getF015n())
                .eqIfPresent(ZcfzBaseDO::getF016n, reqVO.getF016n())
                .eqIfPresent(ZcfzBaseDO::getF085n, reqVO.getF085n())
                .eqIfPresent(ZcfzBaseDO::getF079n, reqVO.getF079n())
                .eqIfPresent(ZcfzBaseDO::getF017n, reqVO.getF017n())
                .eqIfPresent(ZcfzBaseDO::getF117n, reqVO.getF117n())
                .eqIfPresent(ZcfzBaseDO::getF118n, reqVO.getF118n())
                .eqIfPresent(ZcfzBaseDO::getF119n, reqVO.getF119n())
                .eqIfPresent(ZcfzBaseDO::getF018n, reqVO.getF018n())
                .eqIfPresent(ZcfzBaseDO::getF019n, reqVO.getF019n())
                .eqIfPresent(ZcfzBaseDO::getF086n, reqVO.getF086n())
                .eqIfPresent(ZcfzBaseDO::getF020n, reqVO.getF020n())
                .eqIfPresent(ZcfzBaseDO::getF021n, reqVO.getF021n())
                .eqIfPresent(ZcfzBaseDO::getF022n, reqVO.getF022n())
                .eqIfPresent(ZcfzBaseDO::getF023n, reqVO.getF023n())
                .eqIfPresent(ZcfzBaseDO::getF024n, reqVO.getF024n())
                .eqIfPresent(ZcfzBaseDO::getF025n, reqVO.getF025n())
                .eqIfPresent(ZcfzBaseDO::getF026n, reqVO.getF026n())
                .eqIfPresent(ZcfzBaseDO::getF027n, reqVO.getF027n())
                .eqIfPresent(ZcfzBaseDO::getF028n, reqVO.getF028n())
                .eqIfPresent(ZcfzBaseDO::getF029n, reqVO.getF029n())
                .eqIfPresent(ZcfzBaseDO::getF030n, reqVO.getF030n())
                .eqIfPresent(ZcfzBaseDO::getF031n, reqVO.getF031n())
                .eqIfPresent(ZcfzBaseDO::getF032n, reqVO.getF032n())
                .eqIfPresent(ZcfzBaseDO::getF033n, reqVO.getF033n())
                .eqIfPresent(ZcfzBaseDO::getF034n, reqVO.getF034n())
                .eqIfPresent(ZcfzBaseDO::getF035n, reqVO.getF035n())
                .eqIfPresent(ZcfzBaseDO::getF116n, reqVO.getF116n())
                .eqIfPresent(ZcfzBaseDO::getF110n, reqVO.getF110n())
                .eqIfPresent(ZcfzBaseDO::getF111n, reqVO.getF111n())
                .eqIfPresent(ZcfzBaseDO::getF112n, reqVO.getF112n())
                .eqIfPresent(ZcfzBaseDO::getF036n, reqVO.getF036n())
                .eqIfPresent(ZcfzBaseDO::getF037n, reqVO.getF037n())
                .eqIfPresent(ZcfzBaseDO::getF038n, reqVO.getF038n())
                .eqIfPresent(ZcfzBaseDO::getF039n, reqVO.getF039n())
                .eqIfPresent(ZcfzBaseDO::getF087n, reqVO.getF087n())
                .eqIfPresent(ZcfzBaseDO::getF088n, reqVO.getF088n())
                .eqIfPresent(ZcfzBaseDO::getF089n, reqVO.getF089n())
                .eqIfPresent(ZcfzBaseDO::getF040n, reqVO.getF040n())
                .eqIfPresent(ZcfzBaseDO::getF090n, reqVO.getF090n())
                .eqIfPresent(ZcfzBaseDO::getF041n, reqVO.getF041n())
                .eqIfPresent(ZcfzBaseDO::getF042n, reqVO.getF042n())
                .eqIfPresent(ZcfzBaseDO::getF043n, reqVO.getF043n())
                .eqIfPresent(ZcfzBaseDO::getF091n, reqVO.getF091n())
                .eqIfPresent(ZcfzBaseDO::getF092n, reqVO.getF092n())
                .eqIfPresent(ZcfzBaseDO::getF044n, reqVO.getF044n())
                .eqIfPresent(ZcfzBaseDO::getF045n, reqVO.getF045n())
                .eqIfPresent(ZcfzBaseDO::getF046n, reqVO.getF046n())
                .eqIfPresent(ZcfzBaseDO::getF047n, reqVO.getF047n())
                .eqIfPresent(ZcfzBaseDO::getF048n, reqVO.getF048n())
                .eqIfPresent(ZcfzBaseDO::getF049n, reqVO.getF049n())
                .eqIfPresent(ZcfzBaseDO::getF093n, reqVO.getF093n())
                .eqIfPresent(ZcfzBaseDO::getF094n, reqVO.getF094n())
                .eqIfPresent(ZcfzBaseDO::getF095n, reqVO.getF095n())
                .eqIfPresent(ZcfzBaseDO::getF096n, reqVO.getF096n())
                .eqIfPresent(ZcfzBaseDO::getF097n, reqVO.getF097n())
                .eqIfPresent(ZcfzBaseDO::getF050n, reqVO.getF050n())
                .eqIfPresent(ZcfzBaseDO::getF098n, reqVO.getF098n())
                .eqIfPresent(ZcfzBaseDO::getF099n, reqVO.getF099n())
                .eqIfPresent(ZcfzBaseDO::getF113n, reqVO.getF113n())
                .eqIfPresent(ZcfzBaseDO::getF114n, reqVO.getF114n())
                .eqIfPresent(ZcfzBaseDO::getF115n, reqVO.getF115n())
                .eqIfPresent(ZcfzBaseDO::getF051n, reqVO.getF051n())
                .eqIfPresent(ZcfzBaseDO::getF052n, reqVO.getF052n())
                .eqIfPresent(ZcfzBaseDO::getF053n, reqVO.getF053n())
                .eqIfPresent(ZcfzBaseDO::getF054n, reqVO.getF054n())
                .eqIfPresent(ZcfzBaseDO::getF100n, reqVO.getF100n())
                .eqIfPresent(ZcfzBaseDO::getF101n, reqVO.getF101n())
                .eqIfPresent(ZcfzBaseDO::getF055n, reqVO.getF055n())
                .eqIfPresent(ZcfzBaseDO::getF102n, reqVO.getF102n())
                .eqIfPresent(ZcfzBaseDO::getF056n, reqVO.getF056n())
                .eqIfPresent(ZcfzBaseDO::getF057n, reqVO.getF057n())
                .eqIfPresent(ZcfzBaseDO::getF075n, reqVO.getF075n())
                .eqIfPresent(ZcfzBaseDO::getF058n, reqVO.getF058n())
                .eqIfPresent(ZcfzBaseDO::getF059n, reqVO.getF059n())
                .eqIfPresent(ZcfzBaseDO::getF060n, reqVO.getF060n())
                .eqIfPresent(ZcfzBaseDO::getF061n, reqVO.getF061n())
                .eqIfPresent(ZcfzBaseDO::getF062n, reqVO.getF062n())
                .eqIfPresent(ZcfzBaseDO::getF103n, reqVO.getF103n())
                .eqIfPresent(ZcfzBaseDO::getF104n, reqVO.getF104n())
                .eqIfPresent(ZcfzBaseDO::getF105n, reqVO.getF105n())
                .eqIfPresent(ZcfzBaseDO::getF063n, reqVO.getF063n())
                .eqIfPresent(ZcfzBaseDO::getF066n, reqVO.getF066n())
                .eqIfPresent(ZcfzBaseDO::getF074n, reqVO.getF074n())
                .eqIfPresent(ZcfzBaseDO::getF072n, reqVO.getF072n())
                .eqIfPresent(ZcfzBaseDO::getF064n, reqVO.getF064n())
                .eqIfPresent(ZcfzBaseDO::getF076n, reqVO.getF076n())
                .eqIfPresent(ZcfzBaseDO::getF065n, reqVO.getF065n())
                .eqIfPresent(ZcfzBaseDO::getF068n, reqVO.getF068n())
                .eqIfPresent(ZcfzBaseDO::getF073n, reqVO.getF073n())
                .eqIfPresent(ZcfzBaseDO::getF067n, reqVO.getF067n())
                .eqIfPresent(ZcfzBaseDO::getF069n, reqVO.getF069n())
                .eqIfPresent(ZcfzBaseDO::getF070n, reqVO.getF070n())
                .eqIfPresent(ZcfzBaseDO::getF071n, reqVO.getF071n())
                .eqIfPresent(ZcfzBaseDO::getMemo, reqVO.getMemo())
                .eqIfPresent(ZcfzBaseDO::getF120n, reqVO.getF120n())
                .eqIfPresent(ZcfzBaseDO::getF121n, reqVO.getF121n())
                .eqIfPresent(ZcfzBaseDO::getF122n, reqVO.getF122n())
                .betweenIfPresent(ZcfzBaseDO::getCreateTime, reqVO.getCreateTime())
                .orderByDesc(ZcfzBaseDO::getId));
    }

}